inherited frmPosExchPrizeBill: TfrmPosExchPrizeBill
  Caption = #20817#25442#22870#21697
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    inherited pnlThirdtrade: TPanel
      inherited edtTTtraderid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTtraderid: TcxLabel
        AnchorX = 78
      end
      inherited cxLabel1: TcxLabel
        AnchorX = 263
      end
      inherited edtTTamount: TcxDBCalcEdit
        ExplicitHeight = 21
      end
      inherited edtTTremark: TcxDBTextEdit
        ExplicitHeight = 21
      end
      inherited edtTTBalanceid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited edtTTAccountid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTBalanceid: TcxLabel
        AnchorX = 471
      end
      inherited edtTTBalanceamt: TcxDBCalcEdit
        ExplicitHeight = 21
      end
    end
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited edtDate: TcxDBDateEdit
      ExplicitHeight = 21
    end
    inherited edtCode: TcxDBTextEdit
      ExplicitHeight = 21
    end
    inherited DtlPageCtrl: TcxPageControl
      TabOrder = 7
      inherited tabMain: TcxTabSheet
        ExplicitWidth = 0
        ExplicitHeight = 0
      end
      inherited tsSum: TcxTabSheet
        ExplicitWidth = 872
        ExplicitHeight = 258
      end
    end
    inherited edtCreate_time: TcxDBTimeEdit
      ExplicitHeight = 21
    end
    inherited imgCheck: TcxImage
      TabOrder = 5
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynedtCreate_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynedtCheck_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynedtFilid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynedtDeptid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynedtEmpid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
    inherited dynedtBKind: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited pnlTop: TPanel
    inherited edtPrint: TcxLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited pnlBottom: TPanel
    inherited lblDepotQty: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited barBill: TcxProgressBar
      ExplicitHeight = 21
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
    inherited cxGridBandedTableViewStyleSheet1: TcxGridBandedTableViewStyleSheet
      BuiltIn = True
    end
  end
  inherited qryDetail: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posexchprizedtl'
      
        '  (bid, bno, productid, score, aprice, bprice, bquantity, amount' +
        ', unitid, quantity, price, unit1qty, unit2qty, unit3qty, assqty,' +
        ' batchcode, productdate, validdate, relationcount, relationpid, ' +
        'relationqty, relationbtype, relationbid, relationbno, relationbc' +
        'ode, ioqty, custom1, custom2, custom3, custom4, custom5, custom6' +
        ', custom7, custom8, custom9, custom10, custom11, custom12, custo' +
        'm13, custom14, custom15, length, width, height, explan, relation' +
        'assqty)'
      'VALUES'
      
        '  (:bid, :bno, :productid, :score, :aprice, :bprice, :bquantity,' +
        ' :amount, :unitid, :quantity, :price, :unit1qty, :unit2qty, :uni' +
        't3qty, :assqty, :batchcode, :productdate, :validdate, :relationc' +
        'ount, :relationpid, :relationqty, :relationbtype, :relationbid, ' +
        ':relationbno, :relationbcode, :ioqty, :custom1, :custom2, :custo' +
        'm3, :custom4, :custom5, :custom6, :custom7, :custom8, :custom9, ' +
        ':custom10, :custom11, :custom12, :custom13, :custom14, :custom15' +
        ', :length, :width, :height, :explan, :relationassqty)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posexchprizedtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLUpdate.Strings = (
      'UPDATE tb_posexchprizedtl'
      'SET'
      
        '  bid = :bid, bno = :bno, productid = :productid, score = :score' +
        ', aprice = :aprice, bprice = :bprice, bquantity = :bquantity, am' +
        'ount = :amount, unitid = :unitid, quantity = :quantity, price = ' +
        ':price, unit1qty = :unit1qty, unit2qty = :unit2qty, unit3qty = :' +
        'unit3qty, assqty = :assqty, batchcode = :batchcode, productdate ' +
        '= :productdate, validdate = :validdate, relationcount = :relatio' +
        'ncount, relationpid = :relationpid, relationqty = :relationqty, ' +
        'relationbtype = :relationbtype, relationbid = :relationbid, rela' +
        'tionbno = :relationbno, relationbcode = :relationbcode, ioqty = ' +
        ':ioqty, custom1 = :custom1, custom2 = :custom2, custom3 = :custo' +
        'm3, custom4 = :custom4, custom5 = :custom5, custom6 = :custom6, ' +
        'custom7 = :custom7, custom8 = :custom8, custom9 = :custom9, cust' +
        'om10 = :custom10, custom11 = :custom11, custom12 = :custom12, cu' +
        'stom13 = :custom13, custom14 = :custom14, custom15 = :custom15, ' +
        'length = :length, width = :width, height = :height, explan = :ex' +
        'plan, relationassqty = :relationassqty'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLLock.Strings = (
      'SELECT * FROM tb_posexchprizedtl'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRefresh.Strings = (
      
        'SELECT bid, bno, productid, score, aprice, bprice, bquantity, am' +
        'ount, unitid, quantity, price, unit1qty, unit2qty, unit3qty, ass' +
        'qty, batchcode, productdate, validdate, relationcount, relationp' +
        'id, relationqty, relationbtype, relationbid, relationbno, relati' +
        'onbcode, ioqty, custom1, custom2, custom3, custom4, custom5, cus' +
        'tom6, custom7, custom8, custom9, custom10, custom11, custom12, c' +
        'ustom13, custom14, custom15, length, width, height, explan, rela' +
        'tionassqty FROM tb_posexchprizedtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posexchprizedtl'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posexchprizedtl')
  end
  inherited MainDataSet: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posexchprize'
      
        '  (bid, bkind, bstate, bcode, bdate, depotid, memberid, delscore' +
        ', create_by, check_by, deptid, empid, filid, voucherid, relation' +
        'count, custom1, custom2, custom3, custom4, custom5, custom6, cus' +
        'tom7, custom8, custom9, custom10, custom11, custom12, custom13, ' +
        'custom14, custom15, create_time, update_time, remark, costvouche' +
        'rid, score, filtypeid, voucherid2, check_time)'
      'VALUES'
      
        '  (:bid, :bkind, :bstate, :bcode, :bdate, :depotid, :memberid, :' +
        'delscore, :create_by, :check_by, :deptid, :empid, :filid, :vouch' +
        'erid, :relationcount, :custom1, :custom2, :custom3, :custom4, :c' +
        'ustom5, :custom6, :custom7, :custom8, :custom9, :custom10, :cust' +
        'om11, :custom12, :custom13, :custom14, :custom15, :create_time, ' +
        ':update_time, :remark, :costvoucherid, :score, :filtypeid, :vouc' +
        'herid2, :check_time)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posexchprize'
      'WHERE'
      '  bid = :Old_bid')
    SQLUpdate.Strings = (
      'UPDATE tb_posexchprize'
      'SET'
      
        '  bid = :bid, bkind = :bkind, bstate = :bstate, bcode = :bcode, ' +
        'bdate = :bdate, depotid = :depotid, memberid = :memberid, delsco' +
        're = :delscore, create_by = :create_by, check_by = :check_by, de' +
        'ptid = :deptid, empid = :empid, filid = :filid, voucherid = :vou' +
        'cherid, relationcount = :relationcount, custom1 = :custom1, cust' +
        'om2 = :custom2, custom3 = :custom3, custom4 = :custom4, custom5 ' +
        '= :custom5, custom6 = :custom6, custom7 = :custom7, custom8 = :c' +
        'ustom8, custom9 = :custom9, custom10 = :custom10, custom11 = :cu' +
        'stom11, custom12 = :custom12, custom13 = :custom13, custom14 = :' +
        'custom14, custom15 = :custom15, create_time = :create_time, upda' +
        'te_time = :update_time, remark = :remark, costvoucherid = :costv' +
        'oucherid, score = :score, filtypeid = :filtypeid, voucherid2 = :' +
        'voucherid2, check_time = :check_time'
      'WHERE'
      '  bid = :Old_bid')
    SQLLock.Strings = (
      'SELECT * FROM tb_posexchprize'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid')
    SQLRefresh.Strings = (
      
        'SELECT bid, bkind, bstate, bcode, bdate, depotid, memberid, dels' +
        'core, create_by, check_by, deptid, empid, filid, voucherid, rela' +
        'tioncount, custom1, custom2, custom3, custom4, custom5, custom6,' +
        ' custom7, custom8, custom9, custom10, custom11, custom12, custom' +
        '13, custom14, custom15, create_time, update_time, remark, costvo' +
        'ucherid, score, filtypeid, voucherid2, check_time FROM tb_posexc' +
        'hprize'
      'WHERE'
      '  bid = :Old_bid')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posexchprize'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posexchprize')
  end
end
